2013-03-21 - 5910.200 - Rel Notes - Contracts - Release 006 #BIReleases2013

Release Notes:

‍5910.200 - Contracts - SA170

‍Admin Info

Purpose
 Including Contract Information in SA170 report
Release No
 006
Submitted
 03-21-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Mallareddy D
Object(s) Tested By
 Narendra K

‍Report Name

SA170 - Shipped + Open by Region

‍BEx Query

ZMP_OPASA_Q014

NEC Crystal Reports Standards Check

1. SA170 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA170 NEC CR checklist has been sent to NEC and also attached here for reference.
SA170 NEC CR Standard Check List.xlsx

‍Summary Level Check

‍Test Conducted

Report Header
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 31,542,308
 31,542,308
 Pass
2
 Open
 5,523
 5,523
 Pass
3
 Last Year
 17,923,109
 17,923,109
 Pass
4
 Total
 31,547,831
 31,547,831
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 43,161,073
 43,161,073
 Pass
2
 Open
 9,370,488
 9,370,488
 Pass
3
 Last Year
 61,590,962
 61,590,962
 Pass
4
 Total
 52,531,561
 52,531,561
 Pass
‍

Second Level Check

Grouping: Region > Country > Sales Rep > Customer

‍Test Conducted

Group: EMEA
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 4,968,049
 4,968,049
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 1,777,272
 1,777,272
 Pass
4
 Total
 4,968,049
 4,968,049
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 4,422,949
 4,422,949
 Pass
2
 Open
 2,679,385
 2,679,385
 Pass
3
 Last Year
 6,355,149
 6,355,149
 Pass
4
 Total
 7,102,334
 7,102,334
 Pass

Group: Emerging Markets
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 1,616,463
 1,616,463
 Pass
2
 Open
 5,523
 5,523
 Pass
3
 Last Year
 835,799
 835,799
 Pass
4
 Total
 1,621,987
 1,621,987
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 1,336,129
 1,336,129
 Pass
2
 Open
 368,174
 368,174
 Pass
3
 Last Year
 2,160,878
 2,160,878
 Pass
4
 Total
 1,704,303
 1,704,303
 Pass
‍

Third Level Check

‍Test Conducted

Group: EMEA > Andorra
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 7,644
 7,644
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 0
 0
 Pass
4
 Total
 7,644
 7,644
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 5,446
 5,446
 Pass
2
 Open
 923
 923
 Pass
3
 Last Year
 5,398
 5,398
 Pass
4
 Total
 6,368
 6,368
 Pass

Group: Emerging Markets > Australia
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 272,973
 272,973
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 243,910
 243,910
 Pass
4
 Total
 272,973
 272,973
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 275,457
 275,457
 Pass
2
 Open
 48,758
 48,641
 Pass
3
 Last Year
 348,035
 348,035
 Pass
4
 Total
 324,216
 324,099
 Pass

Note: In Open, difference between CR and BEx value is $117, considered as successfully validated.
‍

Fourth Level Check

‍Test Conducted

Group: EMEA > Andorra > Stephane Dauger
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 7,644
 7,644
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 0
 0
 Pass
4
 Total
 7,644
 7,644
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 5,446
 5,446
 Pass
2
 Open
 923
 923
 Pass
3
 Last Year
 5,398
 5,398
 Pass
4
 Total
 6,368
 6,368
 Pass

Group: Emerging Markets > Australia > David Biwer
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 13,801
 13,801
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 97,188
 97,188
 Pass
4
 Total
 13,801
 13,801
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 9,803
 9,803
 Pass
2
 Open
 1,094
 986
 Pass
3
 Last Year
 93,534
 93,534
 Pass
4
 Total
 10,897
 10,789
 Pass
Note: In Open, difference between CR and BEx value is $108, considered as successfully validated.
‍

Fifth Level Check

‍Test Conducted

Group: EMEA > Andorra > Stephane Dauger > OLYMPIA
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 4,872
 4,872
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 0
 0
 Pass
4
 Total
 4,872
 4,872
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 5,446
 5,446
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 4,279
 4,279
 Pass
4
 Total
 5,446
 5,446
 Pass

Group: Emerging Markets > Australia > David Biwer > NEW ERA MARKETING AUSTRALIA
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 2,040
 2,040
 Pass
2
 Open
 0
 0
 Pass
3
 Last Year
 404
 404
 Pass
4
 Total
 2,040
 2,040
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Shipped
 5,761
 5,761
 Pass
2
 Open
 1094
 986
 Pass
3
 Last Year
 404
 404
 Pass
4
 Total
 6855
 6,747
 Pass
Note: In Open, difference between CR and BEx value is $108, considered as successfully validated.

Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports